Zero云平台白皮书

# 运行时插件配置
/plugin/commerce/           # commerce模块配置
/plugin/ambient/            # ambient模块配置

# 系统初始化配置
# commerce模块
/sql/commerce/              # commerce定义文件
/commerce.properties        # commerce独立配置文件
/commerce.yml               # commerce连接文件（真正生产环境使用的是此文件）
# ambient模块
/sql/ambient/
/ambient.properties
/ambient.yml

  # 标准配置（不引入的）
  # - vertx-inject.yml      插件
  # - vertx-error.yml       系统错误定义
  # - vertx-readible.yml    人工错误定义
  # - vertx-server.yml      服务器（容器级）
  # 扩展配置（完整）
  # - vertx-excel.yml       Excel导入
  #     excel
  # - vertx-secure.yml      RBAC安全专用
  #     secure
  #     session
  # - vertx-shell.yml       DevOps命令行工具
  #     shell
  # 应用配置（每个应用不同）
  # - vertx-deployment.yml  开发部署（Agent、Worker、跨域、开发）
  #     cors                  跨域配置
  #     router                Agent路由
  #     deployment            Worker配置
  #     develop               开发专用配置
  # - vertx-detect.yml      集成（数据库、Redis、工作流、缓存、监控）
  #     jooq                  Jooq数据库访问
  #     workflow              Camunda工作流引擎
  #     cache                 缓存
  #     trash                 删除备份专用
  #     redis                 分布式缓存（配合缓存机制）
  #     elasticsearch         ES搜索服务
  #     neo4j                 Neo4J图数据库
  #     monitor               组件监控
  # - vertx-dock.yml        模块化（启动连接、初始化连接、模块加载、扩展组件）
  #     boot                  模块导入
  #     init                  模块初始化
  #     module                模块化加载
  #     extension             扩展组件

( Http Server ) ZeroHttpAgent Http Server has been started successfully. Endpoint: http://198.18.15.157:7085/.

# --------------------- 环境变量专用区域 -----------------------
# 「Aeon」
# 云端资源环境变量
# -- 国外GitHub：  https://github.com/silentbalanceyh/vertx-zero-cloud.git
# -- 国内Gitee：   https://gitee.com/silentbalanceyh/vertx-zero-cloud.git
#
# AEON_CLOUD：基础资源专用环境变量（vertx-zero-cloud）
# -- 工作目录（一般是直接下载后的zero cloud工作目录）
# AEON_APP：应用资源专用目录（出厂设置，云设置）
#
# 这两个目录在容器内都需要支持共享模式，通过K8S的部署实现ConfigMap级别的分布式存储
# 共享，以确保环境中每一类应用的目录是固定的，这种模式下，路径协议变得很重要，此处
# 的路径必须支持路径协议，路径协议是高层处理，根据当前容器使用的SC决定。
# 默认路径规定：
#
AEON_CLOUD=/Users/lang/zero-cloud/vertx-zero-cloud/
AEON_APP=/Users/lang/zero-cloud/cloud-hotel/

# 「Zero」
# 应用级/应用级
# Z_APP：应用程序的code，作为系统路径，或表中的name字段对应
# Z_APP有了过后可以直接通过此一个数值决定其最终运行的环境值
# Z_APP对应的属性
# -- 语言                 多语言
# -- Sigma标识            多应用
# -- TenantID标识         多租户
# -- 前端路由               前端入口
# -- 后端路由               后端入口

# 「Container」
# Z_NS：             名空间信息
# Z_SIGMA：          统一标识符
# Z_LANG：           语言信息
# Z_NS=xxx
# Z_SIGMA=xxx
# X_LANG=cn
Z_APP=app.micro.hotel

# 「Deployment」
# 容器环境专用变量
# ----------------------- 跨域
Z_CORS_DOMAIN=http://ox.server.cn:7005

# ----------------------- RESTful
# Z_API_HOST: 主机地址，0.0.0.0表示任意IP都可访问
# Z_API_PORT: 后端端口
# Z_API_HOST=0.0.0.0
Z_API_PORT=7085

# ----------------------- Sock
# Z_SOCK_HOST: 主机地址，0.0.0.0
# Z_SOCK_PORT: 端口（默认直接挂在API上）
# Z_SOCK_HOST=0.0.0.0
# Z_SOCK_PORT=7085

# ----------------------- DB Service
# Z_DBS_HOST: 数据库连接主机地址
# Z_DBS_PORT: 数据库端口
# Z_DBS_INSTANCE：数据库实例名
# Z_DBS_HOST=ox.engine.cn
# Z_DBS_PORT=3306
# Z_DBS_INSTANCE=DB_HOTEL

# ----------------------- DB Workflow
# Z_DBW_HOST: 数据库连接主机地址
# Z_DBW_PORT: 数据库端口
# Z_DBW_INSTANCE：数据库实例名
# Z_DBW_HOST=ox.engine.cn
# Z_DBW_PORT=3306
# Z_DBW_INSTANCE=DB_HOTEL_WF

# ----------------------- DB History
# Z_DBH_HOST: 数据库连接主机地址
# Z_DBH_PORT: 数据库端口
# Z_DBH_INSTANCE：数据库实例名
# Z_DBH_HOST=ox.engine.cn
# Z_DBH_PORT=3306
# Z_DBH_INSTANCE=DB_HOTEL_HIS

# ----------------------- HED 模块（必须）
Z_HED_ENABLED=true
# ----------------------- 集成服务 System Integration Service
Z_SIS_STORE=/Users/lang/zero-cloud/runtime/store

#!/usr/bin/env bash
# 设置数据库类型（根据数据库类型执行不同流程）
# - 1) 现阶段脚本类型只支持 TIDB 和 MYSQL
# - 2) 远程机中已经部署了 mvn / java / mysql 三种命令
# - 3) 远程机中 non-shell 的环境变量已和 shell 登录模式保持了一致
#      检查远程环境中的 ~/.bashrc 中是否已包含了 mvn / java / mysql 三个命令的基础环境变量
# - 4) 默认数据库账号使用 zero，此处 DB_PASSWORD 对应的是 zero 的密码
# - 5) 默认 DB_ENV = DEV（开发测试环境）
# - 6) DB_ATOM开启动态建模部分
# - 7）Z_HED_ENABLED是否打开加密模块（默认关闭）
# TIDB / MYSQL
export DB_TYPE=MYSQL
export DB_PASSWORD=
export DB_ENV=DEV
export DB_ATOM=
export Z_HED_ENABLED=

// extension/components/integration/document/Cab.module.scss
.upg {
  &_integration_document {
  }
}

// 使用如：
import Sk from 'skin';
import __ from './Cab.module.scss';
....
    const attrs = Sk.mix(__.upg_integration_document);
    // 此处 attrs 已经包含了 className 和 style 属性，且是一个Object
    // 不可以在 jsx 中使用 className="upg_integration_document"
    return (
        <div {...attrs}/>
    )

// zion/variant/LoadingContent/Cab.norm.scss
.uca {
  &_LoadingContent {
    width: 100%;
    text-align: center;
  }
}

// 使用如：
import './Cab.norm.scss'
import Sk from 'skin';
....
    const attrs = Sk.mixUca("LoadingContent");
    // 此处 attrs 已经包含了 className 和 style 属性，且是一个Object
    // 且上述 className 为：uca_LoadingContent
    // 其他地方可以直接使用 className="uca_LoadingContent" 样式
        <div {...attrs}/>

$ cd zone@docker/database-dc-mysql-8
$ cp tpl.zero-mysql-8.env zero-mysql-8.env

MYSQL_ROOT_PASSWORD=
MYSQL_ROOT_HOST=%
MYSQL_USER=zero
MYSQL_PASSWORD=

$ ./zero-mysql-8-@up.sh

$ mysql -u zero -P 3306 -h ox.engine.cn
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.27 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

$ cd zone@terraform/kmini/database-mysql-8
$ cp tpl.initialize.sh initialize.sh

#!/usr/bin/env bash
export TF_VAR_mysql_password=
export TF_VAR_mysql_root_password=
export TF_VAR_mysql_data_path=${PWD}/data

# 编辑完成后执行
$ source ./initialize.sh

# 初始化所有资源
$ terraform init

Initializing the backend...

Initializing provider plugins...
- Finding kreuzwerker/docker versions matching "3.0.1"...
- Installing kreuzwerker/docker v3.0.1...
- Installed kreuzwerker/docker v3.0.1 (self-signed, key ID BD080C4571C6104C)

Partner and community providers are signed by their developers.
If you''d like to know more about provider signing, you can read about it here:
https://www.terraform.io/docs/cli/plugins/signing.html

Terraform has created a lock file .terraform.lock.hcl to record the provider
selections it made above. Include this file in your version control repository
so that Terraform can guarantee to make the same selections by default when
you run "terraform init" in the future.

Terraform has been successfully initialized!

You may now begin working with Terraform. Try running "terraform plan" to see
any changes that are required for your infrastructure. All Terraform commands
should now work.

If you ever set or change modules or backend configuration for Terraform,
rerun this command to reinitialize your working directory. If you forget, other
commands will detect it and remind you to do so if necessary.

# 查看执行计划
$ terraform plan

Terraform used the selected providers to generate the following execution plan. Resource actions are indicated with the following symbols:
  + create

Terraform will perform the following actions:

  # docker_container.terraform-mysql-8 will be created
  + resource "docker_container" "terraform-mysql-8" {
      + attach                                      = false
      + bridge                                      = (known after apply)
      + command                                     = (known after apply)
      + container_logs                              = (known after apply)
      + container_read_refresh_timeout_milliseconds = 15000
      + entrypoint                                  = (known after apply)
      + env                                         = [
          + "MYSQL_PASSWORD=pl,okm123YH",
          + "MYSQL_ROOT_HOST=%",
          + "MYSQL_ROOT_PASSWORD=pl,okmijn123",
          + "MYSQL_USER=zero",
        ]
      + exit_code                                   = (known after apply)
      + hostname                                    = "ox.engine.cn"
      + id                                          = (known after apply)
      + image                                       = "mysql:8.0.32"
      + init                                        = (known after apply)
      + ipc_mode                                    = (known after apply)
      + log_driver                                  = (known after apply)
      + logs                                        = false
      + must_run                                    = true
      + name                                        = "terraform-mysql-8"
      + network_data                                = (known after apply)
      + read_only                                   = false
      + remove_volumes                              = true
      + restart                                     = "no"
      + rm                                          = false
      + runtime                                     = (known after apply)
      + security_opts                               = (known after apply)
      + shm_size                                    = (known after apply)
      + start                                       = true
      + stdin_open                                  = false
      + stop_signal                                 = (known after apply)
      + stop_timeout                                = (known after apply)
      + tty                                         = false
      + wait                                        = false
      + wait_timeout                                = 60

      + healthcheck {
          + interval     = (known after apply)
          + retries      = (known after apply)
          + start_period = (known after apply)
          + test         = (known after apply)
          + timeout      = (known after apply)
        }

      + labels {
          + label = (known after apply)
          + value = (known after apply)
        }

      + networks_advanced {
          + aliases = []
          + name    = "mysql_network"
        }

      + ports {
          + external = 3306
          + internal = 3306
          + ip       = "0.0.0.0"
          + protocol = "tcp"
        }

      + upload {
          + content    = <<-EOT
                GRANT ALL PRIVILEGES ON *.* TO 'zero'@'%';
                FLUSH PRIVILEGES;
            EOT
          + executable = true
          + file       = "/docker-entrypoint-initdb.d/account.sql"
        }
    }

  # docker_image.mysql will be created
  + resource "docker_image" "mysql" {
      + id           = (known after apply)
      + image_id     = (known after apply)
      + keep_locally = true
      + name         = "mysql:8.0.32"
      + repo_digest  = (known after apply)
    }

  # docker_network.private_network will be created
  + resource "docker_network" "private_network" {
      + driver      = (known after apply)
      + id          = (known after apply)
      + internal    = (known after apply)
      + ipam_driver = "default"
      + name        = "mysql_network"
      + options     = (known after apply)
      + scope       = (known after apply)

      + ipam_config {
          + aux_address = (known after apply)
          + gateway     = (known after apply)
          + ip_range    = (known after apply)
          + subnet      = (known after apply)
        }
    }

Plan: 3 to add, 0 to change, 0 to destroy.

─────────────────────────────────────────────────────────────────────────────────────────────

Note: You didn't use the -out option to save this plan, so Terraform can't guarantee to take exactly these actions if you run "terraform apply" now.

# 部署
$ terraform apply

Do you want to perform these actions?
  Terraform will perform the actions described above.
  Only 'yes' will be accepted to approve.

  Enter a value: yes

docker_network.private_network: Creating...
docker_image.mysql: Creating...
docker_image.mysql: Creation complete after 0s [id=sha256:05b458cc32b9686508b97ef40043702c18572840f7b2936b14f06500363868bamysql:8.0.32]
docker_network.private_network: Creation complete after 2s [id=b6285a9e627492f19fcd001830ddd04a6af1e5df4a6c6aeb501ab0965ce6cf45]
docker_container.terraform-mysql-8: Creating...
docker_container.terraform-mysql-8: Creation complete after 1s [id=b651230638dd8bd576b5ac54bd2edca751154ddafcfd12b1201da6be0e1956e6]

Apply complete! Resources: 3 added, 0 changed, 0 destroyed.

$ cd zone@docker/database-dc-pgsql
$ cp tpl.zero-pgsql.env zero-pgsql.env

POSTGRES_PASSWORD=
POSTGRES_USER=postgres
POSTGRES_DB=postgres
TZ=Asia/Shanghai

$ ./zero-pgsql-@up.sh

$ cd zone@terraform/kmini/database-pgsql
$ cp tpl.initialize.sh initialize.sh

#!/usr/bin/env bash
export TF_VAR_pgsql_password=
export TF_VAR_pgsql_data_path=${PWD}/data

# 编辑完成后执行
$ source ./initialize.sh

$ terraform init
$ terraform plan
$ terraform apply

$ tiup update --self && tiup update cluster

# tiup playground v6.5.0 --db 2 --pd 3 --kv 3 --tag tidb-zero
$ ./tidb-start.sh
tiup is checking updates for component playground ...
Starting component `playground`: /Users/lang/.tiup/components/playground/v1.11.2/tiup-playground v6.5.0 --db 2 --pd 3 --kv 3 --tiflash 0 --tag tidb-zero
Playground Bootstrapping...
Start pd instance:v6.5.0
Start pd instance:v6.5.0
Start pd instance:v6.5.0
Start tikv instance:v6.5.0
Start tikv instance:v6.5.0
Start tikv instance:v6.5.0
Start tidb instance:v6.5.0
Start tidb instance:v6.5.0
Waiting for tidb instances ready
127.0.0.1:4000 ... Done
127.0.0.1:4001 ... Done
CLUSTER START SUCCESSFULLY, Enjoy it ^-^
To connect TiDB: mysql --comments --host 127.0.0.1 --port 4001 -u root -p (no password)
To connect TiDB: mysql --comments --host 127.0.0.1 --port 4000 -u root -p (no password)
To view the dashboard: http://127.0.0.1:2379/dashboard
PD client endpoints: [127.0.0.1:2379 127.0.0.1:2382 127.0.0.1:2384]
To view the Prometheus: http://127.0.0.1:9090
To view the Grafana: http://127.0.0.1:3000